package com.bm.server.dao;

import com.bm.server.dto.WerewolfDto;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * .=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-.
 * |                     ______                     |
 * |                  .-"      "-.                  |
 * |                 /            \                 |
 * |     _          |              |          _     |
 * |    ( \         |,  .-.  .-.  ,|         / )    |
 * |     > "=._     | )(__/  \__)( |     _.=" <     |
 * |    (_/"=._"=._ |/     /\     \| _.="_.="\_)    |
 * |           "=._"(_     ^^     _)"_.="           |
 * |               "=\__|IIIIII|__/="               |
 * |              _.="| \IIIIII/ |"=._              |
 * |    _     _.="_.="\          /"=._"=._     _    |
 * |   ( \_.="_.="     `--------`     "=._"=._/ )   |
 * |    > _.="                            "=._ <    |
 * |   (_/                                    \_)   |
 * |                                                |
 * '-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-='
 * -----------------代码的搬运工-----------------
 *
 * @Date: 2022/07/19/17:09
 */
public interface WerewolfDtoDao {
    @Select("SELECT td.uid, tr.roomname, tu.headurl FROM t_dogkill as td,t_room_head as tr,t_userinfo as tu WHERE td.uid = tu.uid AND tr.roomid = td.roomid AND td.roomid =1")
    List<WerewolfDto> roomlist();
    @Select("SELECT td.uid, tr.roomname, tu.headurl FROM t_dogkill as td,t_room_head as tr,t_userinfo as tu WHERE td.uid = tu.uid AND tr.roomid = td.roomid AND td.roomid =2")
    List<WerewolfDto> roomlist2();
    @Select("SELECT td.uid, tr.roomname, tu.headurl FROM t_dogkill as td,t_room_head as tr,t_userinfo as tu WHERE td.uid = tu.uid AND tr.roomid = td.roomid AND td.roomid =3")
    List<WerewolfDto> roomlist3();
    @Select("SELECT td.uid, tr.roomname, tu.headurl FROM t_dogkill as td,t_room_head as tr,t_userinfo as tu WHERE td.uid = tu.uid AND tr.roomid = td.roomid AND td.roomid =4")
    List<WerewolfDto> roomlist4();
    @Select("SELECT td.uid, tr.roomname, tu.headurl FROM t_dogkill as td,t_room_head as tr,t_userinfo as tu WHERE td.uid = tu.uid AND tr.roomid = td.roomid AND td.roomid =5")
    List<WerewolfDto> roomlist5();
}
